-- ------------------------------------------------------------------------------------------- --
--                                Formel 1 Datenbank                                           --
-- ------------------------------------------------------------------------------------------- --
-- Prof. Susanne Busse
-- Januar 2010

-- Skript zum Loeschen der Datenbank (Sybase ASE)

if exists (select 1
            from  sysobjects
            where id = object_id('GefahrenVon')
            and   type = 'U')
   drop table GefahrenVon
go

if exists (select 1
            from  sysobjects
            where id = object_id('Rennen')
            and   type = 'U')
   drop table Rennen
go

if exists (select 1
            from  sysobjects
            where id = object_id('SetztEin')
            and   type = 'U')
   drop table SetztEin
go

if exists (select 1
            from  sysobjects
            where id = object_id('Rennfahrer')
            and   type = 'U')
   drop table Rennfahrer
go

if exists (select 1
            from  sysobjects
            where id = object_id('Rennstall')
            and   type = 'U')
   drop table Rennstall
go

if exists (select 1
            from  sysobjects
            where id = object_id('Saison')
            and   type = 'U')
   drop table Saison
go

if exists (select 1
            from  sysobjects
            where id = object_id('Rennstrecke')
            and   type = 'U')
   drop table Rennstrecke
go

if exists (select 1
            from  sysobjects
            where id = object_id('Land')
            and   type = 'U')
   drop table Land
go

